Business Case #3 - Market Basket Analysis

Authors:

Débora Santos (m20200748),Pedro Henrique Medeiros (m20200742), Rebeca Pinheiro (m20201096)

Group D - D4B Consulting

Installing and import packages

Maybe it will be necessary install some 'special' packages to this notebook works.

Please follow the next cells and check if it's necessary

Collect initial data

Describe, explore and assess data quality

Customers' behaviors

Products and departments most consumed

The criteria used to select the products that have highest number of itens sold and appears in the most orders. We are going to demonstrated that few products represents more than 50% sales and appears in 10% of orders. The other products have low representativeness.

Behaviors by product

Apriori Algorithm and Association rules

Pivot Table

Frequent Items

Association Rules

Complementary Products

Substitute Products

Heat Map of Complementary Produtcs

Complementary Products Plot

The default settings of this graph do not provide a clear visualization of its elements. Therefore, for a better placement for the plot elements and an overall better visualization, it was choosen that the boxes (representing the products) can be manually dragged, allowing the user to create a better plot.